* cd - fill with the appropriate folder

use Dados Paper.dta

* Variable Labels for Board Diversity and Financial Performance Study
* Company and Year Identifiers
label variable iddaempresa "Company Identifier"
label variable year "Year"

* Board Member Info
label variable boardmember "Board Member Identifier"
label variable coefficientofvariationage "Age Coefficient of Variation of Board Members"
label variable averageage "Average Age of Board Members"

* Gender Diversity
label variable nobsgender "Number of Observations with Gender Info"
label variable f "Share of Female Board Members"
label variable least1f "Dummy: At least one female member"

* Educational Background
label variable ndicedeblaugraudegraduao "Blau Index - Educational Attainment"
label variable ndicedeblauclassformao "Blau Index - Field of Study"

* Independence and Other Experience
label variable independente "Share of Independent Board Members"
label variable membrode1conselho "Share of Members in Multiple Boards"
label variable dummy1conselho "Dummy: At least one member with experience on other boards"

* Family Ties and Executive Duality
label variable comlaosfamiliares "Share of Members with Family Ties"
label variable least1memberlaosfamiliares "Dummy: At least one member with family ties"
label variable diretoria "Share of Board Members in Executive Management"
label variable dummyceo "Dummy: CEO is also a Board Member"

* Financial Information
label variable totalativo "Total Assets"
label variable ltotalativo "Log of Total Assets"
label variable dividadivpl "Leverage Ratio (Debt / (Debt + Equity))"
label variable qtobin "Tobin's Q"
label variable roa "Return on Assets"
label variable roi "Return on Equity"
label variable lroa "Log (ROA + 1)"
label variable lqtobin "Log Tobin's Q"
label variable lroi "Log (ROE + 1)"


*Table 15 (Main Results)
xtset iddaempresa year
set more off
eststo: quietly xtreg lroa ndicedeblaugraudegraduao  ndicedeblauclassformao  membrode1conselho  comlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  f  ltotalativo   dividadivpl  boardmember i.year, fe cluster(iddaempresa)
eststo: quietly xtreg lroa ndicedeblaugraudegraduao  ndicedeblauclassformao  dummy1conselho  least1memberlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  least1f  ltotalativo   dividadivpl  boardmember  i.year, fe cluster(iddaempresa)
eststo: quietly xtreg lroi ndicedeblaugraudegraduao  ndicedeblauclassformao  membrode1conselho  comlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  f  ltotalativo   dividadivpl  boardmember i.year, fe cluster(iddaempresa)
eststo: quietly xtreg lroi ndicedeblaugraudegraduao  ndicedeblauclassformao  dummy1conselho  least1memberlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  least1f  ltotalativo   dividadivpl  boardmember  i.year, fe cluster(iddaempresa)
eststo: quietly xtreg lqtobin ndicedeblaugraudegraduao  ndicedeblauclassformao  membrode1conselho  comlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  f  ltotalativo   dividadivpl  boardmember  i.year, fe cluster(iddaempresa)
eststo: quietly xtreg lqtobin ndicedeblaugraudegraduao  ndicedeblauclassformao  dummy1conselho  least1memberlaosfamiliares   diretoria  dummyceo  independente  coefficientofvariationage  least1f  ltotalativo   dividadivpl  boardmember i.year, fe cluster(iddaempresa)
esttab  using "Tabela15", replace plain lines  compress  brackets t(3) b(3) staraux star(* 0.10 ** 0.05 *** 0.01) se csv
est clear



